import pandas as pd
data = pd.read_excel('F:\\python\\第7章\\各分店销售表.xlsx', sheet_name=0)
a = pd.pivot_table(data, values='销量', index='分店名', columns='销售月份', aggfunc='sum')
print(a)
